USE [Forums]
GO

/****** Object:  View [dbo].[V_QuestionComplete]    Script Date: 08/13/2012 11:54:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[V_QuestionComplete]
AS
SELECT     dbo.ASK_Question.q_ID, dbo.ASK_Question.name, dbo.ASK_Question.title, dbo.ASK_Question.description, dbo.ASK_Question.forumID, dbo.ASK_Question.viewed, 
                      dbo.ASK_Question.userID, dbo.ASK_Question.publishDate, dbo.Users.UserName, dbo.Users.UserPhoto, dbo.ASK_Question.isActive
FROM         dbo.ASK_Question INNER JOIN
                      dbo.Users ON dbo.ASK_Question.userID = dbo.Users.UserId

GO


